Shareware Grab Bag

home *** CD-ROM | disk | FTP | other *** search

/ Shareware Grab Bag / Shareware Grab Bag.iso / 019 / 123lrn22.arc / 123LEARN.DOC next >

Wrap

Text File | 1987-07-13 | 18KB | 595 lines

123-LEARN Version 2.2 produced by Softsmith Enterprises tm (c) 1987 All Rights Reserved (earlier versions of this product were not published) This product isn't copy-protected. The spreadsheet has been restricted from direct access only to insure there is always an unaltered copy of the facility for backup and distribution. PLEASE DON'T ATTEMPT TO RESAVE THE SPREADSHEET FILE! (You may inadvertently lose your copy of the facility!) User agreement, manual and registration form are all available at this point provided you have a printer on-line. Or, you may view the documentation on your screen by retrieving "123LEARN.WK1" in Lotus 123 version 2.0 and up, or you may get your hardcopy immediately by printing this document file. Instructions for installing the facility in your Lotus files follow... Installing 123-LEARN: #1- Go to an empty range in your spreadsheet at least 10 wide by 56 deep. 123-Learn will be installed here. #2- Insert 123-Learn disk in default drive (usually "b:") #3- Make sure the mode indicator (upper right) says READY #4- Type "/FCCN123-Learn" [PRESS RETURN TWICE] continue typing "/RNC\" (don't type the quotation marks!). #5- Now specify a letter you want to use when you invoke 123-Learn (The facility will activate whenever you type "ALT" and the letter at the same time) [PRESS RETURN TWICE] #6- Press "ALT" and your chosen letter at the same time. (Be sure 123-Learn disk is still in default drive) #7- After a few moments, 123-Learn will be installed- try it. Using 123-LEARN: #1- Initially, 123-Learn brings up the main menu to get data on the current task: GO NEW APPEND DISPLAY QUIT #1a- The "go" command invokes the last macro you worked on. #1b- The "new" command allows you to make temporary or permanent macros, and prompts you to show it where you want permanent macros written. Temporary macros are written below 123-Learn automatically. #1c- The "append" command adds the following keystrokes to the last macro you worked on- this is best done after using the "go" command to show you where you are. #1d- The "display" command shows the current display of the command line-press any key to return to the main menu. #1e- The "quit" command stops learn-mode, but the "append" command may still be used later on. "Quit" can be used to make unrecorded keystrokes before continuing. Using 123-Learn: #2- While 123-Learn is on, each keystroke made is recorded in a macro so tasks may be repeated automatically! #3- 123-Learn is usually transparent to the user- you know it's on only by the "CMD" indicator at the bottom of the screen. #4- 123-Learn isn't transparent to the user when backslash "\" is pressed. Then, the facility brings up this menu: DONE FIELD* PAUSE* WAIT* RESUME SOUND ~ MACROS #4a- Pressing the [ESC] key will rid you of the menu. The "\" will be typed normally and learn mode will continue. #4b- The "done" feature simply embeds a terminating command in the macro and brings the main menu back up. (N.B. The command used is "{return}", not "{quit}") * When using these features, check the upper-right indicator for status 123-LEARN features: #1- The "field" feature lets you embed pauses in the macro for users to type in data. When you call this feature, FIELD is shown in the upper-right box (the indicator). no keystrokes will be recorded until the you press [RETURN]. Then you can continue in learn mode. #2- The "pause" feature lets you embed pauses in the macro until the user presses any key- there is no opportunity for input. When you call this feature, PAUSE is shown in the upper-right box (the indicator). execution is suspended until a key is pressed- then learn mode resumes. N.B.: A range named "L22\" is used by all macros with embeded pauses, deleting this range name invalidates the macros. 123-LEARN features: #3- The "wait" feature prompts you to input the time to wait in the format x,x,x where x is: [number of hours to wait],[minutes to wait],[and seconds] WAIT shows in the indicator for the specified period. #4- The "sound" feature embeds and plays beeps when numbers are typed. It is turned on/off like a light switch. #5- The "resume" feature continues learn-mode as though you'd never typed "\" (note "\" is not typed). #6- If you want to type "~", you have to use the "~" feature, since "~" is a macro symbol for [RETURN], typing it directly will do the same thing as pressing [RETURN]. #7- The "macro" feature brings up a menu of advanced options... 123-LEARN advanced features: #7(cont)- The "macro" feature brings up the following menu: LOOP KNOT DOWN IF NOT ROUTINE MENU BELL #1- Using the "loop" feature causes the macro to start over again from the beginning- it will stop learn mode unless you're in a conditional routine (see "if" feature). #2- The "knot" feature funtions like the "loop", except it repeats the macro from the beginning of the current macro line (keep track of macro lines with the "bell" feature). N.B.: Macros with this feature can't be moved to new addresses. #3- Using the "down" feature will force the macro to write all further keystrokes in the next cell below the cell in which it's currently writing. This happens automatically when the current cell is full unless a condi- tional routine is in progress (see "interruptions"). 123-LEARN advanced features: #4- The "if" feature lets you specify certain keystrokes that will only be executed under certain conditions. (a "conditional routine"). This menu is brought up: EQUATION VALUE LABEL #4a- The "equation" feature prompts you to input a specific equation that must be true to execute the conditional routine. #4a(1)- Not specifying any equation will cause the conditional routine to execute as the curser encounters a blank cell. #4b- The "value" feature prompts for a number or a numeric formula (example: +a1+(b1*c1) ). #4b(1)- Not specifying any value will cause the conditional routine to execute as the curser encounters any cell containing a value. 123-LEARN advanced features: #4c- The "label" feature prompts for a label, or a string formula (example: +a1&@left(b1,3)&c1 ) #4c(1)- A label must be input in quotes ("example"). #4c(2)- Do not put string formulas in quotes. #4a(1)- Not specifying any string will cause the conditional routine to execute as the curser encounters a any cell containing a label. #4b- The conditional routine continues until: #4b(1)- You press "\d" (for "done") - This causes a conditional termination of macro execution. #4b(2)- You use the "loop" or "knot" feature - This causes a conditional repetition of the macro. #4b(3)- You use the "down" feature - This means the macro continues normally after the condition- al routine is finished. #4c- When the routine is done, normal learn mode resumes. #5- The "not" feature executes routine if a condition's false. 123-LEARN advanced features: #6- The "routine" feature causes the macro you're making to invoke another macro. After entering a macro name, you tell 123-Learn what to do after the invoked macro is done. #6a- If the invoked macro contains the "{RESTART}" or "{QUIT}" commands, it won't return "control" to the original macro when finished. #6b- Deleting these commands will cause the invoked macro to return to the original macro and execute the rest of the keystrokes you recorded there. #6c- You are free to specify a nonexistant macro, as long as you make a macro under that name before you try to invoke it. #7- The "menu" feature calls a macro menu like the "routine" feature calls a macro. #8- The "bell" feature causes a bell to sound when 123-Learn fills the cell it's currently writing in. 123-LEARN interruptions: #1- 123-LEARN may occaisionally interrupt learning to ask if you want a specific cell's contents written over. This is because the current cell is full, but the next cell already has contents. Toggle between the choices given to alternately see both the displayed value and formulaic contents of the threatened cell. #2- Triggering a 123-error while using 123-LEARN will cause the facility to display the cause of the error, and return you to the main menu. Control-Break will bring you straight to the main menu as though you'd type "\d(one)." #3- Erasing the worksheet or calling a new file while using 123-Learn will cause you to loose all macro commands that have been recorded since you last saved the file. These commands should be typed into the macro manually and the file should be saved before invoking the macro. 123-LEARN general considerations: #1- Enabling 123's "protection" feature (by typing "/w(orksheet)g(lobal)p(rotection)e(nable)") could trigger unrecoverable macro errors if the macro area isn't unprotected (temporary macro storage is directly under the 123-Learn program in your spreadsheet). #2- Inputing invalid equations, routine names or formulas using the "macro" or "if" features will result in unrecoverable errors when a macro generated with 123-Learn is executed. #3- Starting a temporary macro while in edit mode will cause unexpected results to appear on the command line while 123-Learn is being used. This is due to Lotus 123 software design. Regardless of the unexpected results, the new macro will function as expected when invoked through 123-Learn. #4- Try to make the macro in the tutorial worksheet "tutor.wk1" It will show you how 123-Learn can be fully utilized! 123-LEARN User Agreement: You are hereby provided a license to use 123-Learn provided the following conditions typical of user-supported software: #1- Payment of billing as calculated under the billing section of this Agreement. #2- No receipt of any form of remuneration or consideration for distribution of this product to others beyond those verifiable costs of disks, P.C. rentals, ect. - Individuals or institutions receiving 123-Learn will either pay the regular billing to Softsmith Enterprise or it will be payed by the distributor, provided the distributor is authorized to do so under the distribution agreement (see below). #3- In no event will the author be liable to you or any other person for any damages direct, incidental or consequential arising out of the use or inability to use this product. 123-LEARN Distribution Agreement: You are hereby provided a license to distribute 123-Learn free of charge provided the following conditions. #1- The software and/or documentation of this product are not altered in any way whatsoever. #2- You don't qualify as a purchaser for those to whom 123-Learn is distributed (as defined below). If you distribute 123-Learn to employees or other subordinates under your management, or are a designated software/office supply purchaser of an institution to whom 123-Learn is distributed, you are required to pay, or cause the institution to pay, for each user's copy as calculated under the billing section of this Agreement (volume discounts available) A user is defined as any individual who by requirements of employment can and do use 123-Learn. Users of macros created using 123-Learn are not necessarilly users as defined here. 123-LEARN billing: 123-Learn costs ten dollars ($10.00) per user, with a two dollar ($2.00) discount for each user beyond 1 to whom a copy is distributed by a purchaser as defined under the Distribution Agreement. See chart: Number of users Itemized billing Total billing 1 $10 $10.00 2 10+8 $18.00 3 10+8+6 $24.00 4 10+8+6+4 $28.00 5 10+8+6+4+2 $30.00 6 ad infinitum 10+8+6+4+2+0 $30.00 N.B.: Those who do not receive this product from a purchaser as defined under the Distribution Agreement are required to calculate their billing anew, counting themselves as user #1. 123-LEARN User Registration Form: __________________ | Place __________________ | Stamp __________________ | Here `-------- Softsmith Enterprises 1425 Denman Avenue Coshocton, Ohio 43812 ________________________________________________________________________ fold here ________________________________________________________________________ fold here I've found 123-Learn, Version 2.2 to be a valuable facility, here is my payment of billing as calculated under the User Agreement: IF CHECK IS NOT ENCLOSED, NAME OF CREDIT/ #/USERS: ________ ENTER CREDIT/BANK CARD NUMBER BANK CARD: BILLING: $_______ ___________________________ __________________ ________________________________________________________________________ fold here I'd also like to order these other Softsmith products: PRODUCT BILLING PRICE No./Users(Discount $1 for each 123-LOCK $_______ $5.00 _________for each user over one) APGR $0.00 _________ (Included a prestamped disk envelope with any APGR order!) Ohio residents include 5½% sales tax DO NOT SEND $CASH$!!! --(tear)------------(tear)------------(tear)------------(tear)---------- (This is your payment envelope, stamp, return address and seal the edges- then send! Thanks for the registration!) Other products developed by Softsmith Enterprizes: 123-LOCK: Provides superior spreadsheet protection any time you need it- quick keyboard lock-up/screen-blank while in a file, on retrieving a file or when 123 boots-up; 123-Lock insures that your files/system will be untampered with in five minutes or five years! Uses your password. May be invoked from a macro. APGR: This automated spreadsheet finds the average periodic growth rate and standard error of any time series data as a percent, useful in forecasts and measuring your performance against financial targets (usually expressed as percentages also!) 123-LEARN End: Thank you for your time thus far. Hopefully 123-Learn will become a valuable productivity tool to you. If not, or if you see room for improvements, please use the registration form to let us know. User supported software cannot require billing of unsatisfied users... Note: Lotus and 123 are trademarks of Lotus Development Corp.